Skip to main content
This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal

Notes/Domino 6 and 7 Forum

Notes/Domino 6 and 7 Forum


  

PreviousPrevious NextNext

RE: How to get 7 values out of more than 2'000'000 documents
~Naomi Deskroterakol 2.Dec.03 05:58 PM a Web browser
Applications Development 6.0.2 CF2 Windows 2000


Nonsense. Notes has been able to handle this kind of volume for some time. Ten times that much and you might run into problems. But 2 million documents are easily supported in a well-designed application. When we take into account the fact that these databases are logs, and therefore the growth rate is known and prior information is not subject to change, there's no reason not to do it this way. 2 million docs over a year is less than 10000 per day, which (assuming a 16 hour usage period) is about 625 per hour, which is about 10 a minute. Well-within the capacity of the Domino indexer, particularly if you bother to schedule an UPDALL at night to ensure up-to-date indexes in current logs.

That being said, Andre is quite right in his remark that this would be better done by not creating an individual document for each search log, and instead storing global line item documents that record search information in list structures within single documents. Undoubtedly this system already has profile documents for users of some kind, and any individual user is not likely to have performed more than 1000 searches or so in a given year. So recording the logs in that user profile should be easy, and would make searching for a given user pretty much instantaneous -- since you're only resorting list structures within a single document context, instead of sorting millions of documents.

But it's not necessary. If your log databases have an appropriate structure to them, and you build two or three views with intelligent category structures, this should all be very easy through embedded views and "show single category."




How to get 7 values out of more tha... (~Lorraine Desge... 1.Dec.03)
. . RE: How to get 7 values out of more... (~Bill Frokimari... 1.Dec.03)
. . . . RE: How to get 7 values out of more... (~Lorraine Desge... 1.Dec.03)
. . . . . . RE: How to get 7 values out of more... (~Keiko Cisfoote... 1.Dec.03)
. . . . . . . . RE: How to get 7 values out of more... (~Naomi Deskrote... 2.Dec.03)
. . . . RE: How to get 7 values out of more... (~Lorraine Desge... 2.Dec.03)
. . . . . . RE: How to get 7 values out of more... (~Naomi Deskrote... 2.Dec.03)
. . RE: How to get 7 values out of more... (~Bella Kiresath... 2.Dec.03)
. . . . RE: How to get 7 values out of more... (~Bill Frokimari... 2.Dec.03)
. . . . . . RE: How to get 7 values out of more... (~Bella Kiresath... 3.Dec.03)


Document Options






  Document options
Print this pagePrint this page

Search this forum

Forum views and search


  Forum views and search
Date (threaded)
Date (flat)
With excerpt
Category
Platform
Release
Advanced search

Member Tools


RSS Feeds

 RSS feedsRSS
All forum posts RSS
All main topics RSS